Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
LanguageID (FK)(PK) | A combination of ISO-639-1 and ISO-3661-1 to denote a lanuage as spoken in a particular country. | ID_LGE | Code4External | char(4) | Language(CO_LGE) |
ItemID (FK)(PK) | A unique system assigned identifier for the retailer's SKU. | ID_ITM | IdentityUUID | char(32) | Item(AS_ITM) |
ItemName | The name of the Item translated into the nominated Language. | NM_ITM | Name | varchar(40) | |
Description | The description of the Item translated into the nominated Language. | DE_ITM_TSL | DescriptionShort | varchar(255) | |